USE mseauth;

CREATE TABLE `accounts` (
  `Id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `GivenName` varchar(100) DEFAULT '',
  `Surname` varchar(100) DEFAULT '',
  `Email` varchar(100) NOT NULL,
  `Region` tinyint(4) unsigned NOT NULL,
  `Language` varchar(4) DEFAULT NULL,
  `Salt` varchar(255) DEFAULT NULL,
  `IP` varchar(15) DEFAULT NULL,
  `LoginFailures` tinyint(4) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;